Power BI Model Explorer

{{ modelData.statistics.total_tables }} tables ยท {{ modelData.statistics.total_measures }} measures ยท {{ modelData.statistics.total_relationships }} relationships

Model Explorer

Browse all tables and measures in your Power BI model

{{ table.table_type === 'fact' ? '๐Ÿ“Š' : '๐Ÿ“' }}

{{ table.table_type === 'fact' ? 'f' : 'd' }} {{ table.name }}

{{ table.statistics.column_count }} cols {{ table.statistics.measure_count }} meas {{ table.statistics.relationship_count }} rels
{{ table.complexity }}

๐Ÿ“Š Model Summary

Overview

Total Tables {{ modelData.statistics.total_tables }}
Total Measures {{ modelData.statistics.total_measures }}
Total Relationships {{ modelData.statistics.total_relationships }}

Table Types

๐Ÿ“ Dimensions {{ modelData.statistics.dimension_tables }}
๐Ÿ“Š Facts {{ modelData.statistics.fact_tables }}

Relationships

Active {{ modelData.statistics.active_relationships }}
Inactive {{ modelData.statistics.inactive_relationships }}
Disconnected Tables {{ modelData.statistics.tables_with_no_relationships }}

Model Health

Unused Measures {{ modelData.statistics.unused_measures }}
Measures with Dependencies {{ modelData.statistics.measures_with_dependencies }}
Model Complexity
LOW HIGH MEDIUM

Tables

{{ table.name }}
{{ table.statistics.column_count }} columns ยท {{ table.statistics.measure_count }} measures
{{ table.table_type }} {{ table.complexity }}
Hidden

{{ selectedTable.name }}

{{ selectedTable.description }}

{{ selectedTable.table_type.toUpperCase() }} Complexity: {{ selectedTable.complexity.toUpperCase() }}
Rows
{{ formatNumber(selectedTable.row_count) }}
Columns
{{ selectedTable.statistics.column_count }}
Measures
{{ selectedTable.statistics.measure_count }}
Relationships
{{ selectedTable.statistics.relationship_count }}
No columns found for this table
{{ column.name || '(unnamed column)' }} ๐Ÿ”‘ Key
Type: {{ column.data_type || 'String' }}
โ†’
{{ measure.name }} ๐Ÿ“ {{ measure.folder }}

Incoming ({{ selectedTable.relationships_in.length }})

{{ rel.from_table }} [{{ rel.from_column }}] โ†’ {{ selectedTable.name }} [{{ rel.to_column }}]
{{ rel.active ? 'Active' : 'Inactive' }} {{ rel.cardinality }}

Outgoing ({{ selectedTable.relationships_out.length }})

{{ selectedTable.name }} [{{ rel.from_column }}] โ†’ {{ rel.to_table }} [{{ rel.to_column }}]
{{ rel.active ? 'Active' : 'Inactive' }} {{ rel.cardinality }}
No relationships for this table
{{ usage.measure_table }} / {{ usage.measure_name }}
This table is not referenced in any measures

Loading data preview...

โš ๏ธ
Error loading data preview

{{ tablePreviewError }}

Showing {{ tablePreviewData.rows.length }} of {{ formatNumber(selectedTable.row_count) }} rows
# {{ column }}
{{ rowIdx + 1 }} {{ formatCellValue(row[column]) }}
Click "๐Ÿ“Š Data Preview" to load sample data

Select a table from the list to view its details

Measures

{{ selectedMeasure.name }}

{{ selectedMeasure.table }}

{{ selectedMeasure.description }}

MEASURE Complexity: {{ selectedMeasure.complexity.toUpperCase() }}
Hidden ๐Ÿ“ {{ selectedMeasure.folder }}

DAX Expression

Dependencies (Uses)

Measures ({{ selectedMeasure.depends_on.measures.length }})

{{ dep.table }} / {{ dep.measure }}

Columns ({{ selectedMeasure.depends_on.columns.length }})

{{ col.table }} / {{ col.column }}

Used By ({{ selectedMeasure.used_by_measures.length }} measures)

{{ usage.table }} / {{ usage.measure }}

โš ๏ธ This measure is not used by any other measures. It may be unused or only referenced in reports.

Select a measure from the list to view its details

Relationship Graph

Dimension (d_)
Fact (f_)
Slicer (s_)

Selected: {{ selectedNode }}

Click on a table to highlight its relationships

Dependency Graph

{{ dependencyDepth }} levels
Showing dependencies up to {{ dependencyDepth }} {{ dependencyDepth === 1 ? 'level' : 'levels' }} from the focused node
Table
Measure
Column
Click a node to highlight | Drag to reposition | Scroll to zoom
{{ modelData.dependency_graph.nodes?.length || 0 }} nodes | {{ modelData.dependency_graph.edges?.length || 0 }} edges

{{ selectedDependencyNode.label }}

Type: {{ selectedDependencyNode.type }}
Table: {{ selectedDependencyNode.table }}
Complexity: {{ selectedDependencyNode.complexity }}
Data Type: {{ selectedDependencyNode.data_type }} Used in: {{ selectedDependencyNode.used_in_count }} measure(s)
DAX Expression:
{{ modelData.dependency_graph.statistics.measure_count }}
Measures
{{ modelData.dependency_graph.statistics.column_count }}
Columns
{{ modelData.dependency_graph.statistics.table_count }}
Tables
{{ modelData.dependency_graph.statistics.total_edges }}
Dependencies

โš ๏ธ Circular Dependencies Detected

Found {{ modelData.dependency_graph.statistics.circular_references.length }} circular dependency path(s). These can cause calculation errors.

Model Overview

Total Tables {{ modelData.statistics.total_tables }}
Total Columns {{ modelData.statistics.total_columns }}
Total Measures {{ modelData.statistics.total_measures }}
Total Relationships {{ modelData.statistics.total_relationships }}

Relationships

Active {{ modelData.statistics.active_relationships }}
Inactive {{ modelData.statistics.inactive_relationships }}
Disconnected Tables {{ modelData.statistics.tables_with_no_relationships }}

Measures

With Dependencies {{ modelData.statistics.measures_with_dependencies }}
Unused {{ modelData.statistics.unused_measures }}

โŒจ๏ธ Keyboard Shortcuts

/ Focus search box
Ctrl/Cmd + K Toggle command palette
Alt + โ† / โ†’ Navigate between tabs
Escape Close modals / Clear search

Quick Actions

{{ selectedColumn.column.name }}

{{ selectedColumn.table.name }}

Column Properties

Data Type:

{{ selectedColumn.column.data_type }}

Key:

{{ selectedColumn.column.key ? 'Yes' : 'No' }}

Hidden:

{{ selectedColumn.column.hidden ? 'Yes' : 'No' }}

Usage in Model

This column is used in {{ selectedColumn.table.used_in_measures.length }} measures and {{ selectedColumn.table.relationships_in.length + selectedColumn.table.relationships_out.length }} relationships.

Relationship Details

{{ selectedRelationship.from_table }} [{{ selectedRelationship.from_column }}]
โ†’
{{ selectedRelationship.to_table }} [{{ selectedRelationship.to_column }}]
Status:

{{ selectedRelationship.active ? 'Active' : 'Inactive' }}

Cardinality:

{{ selectedRelationship.cardinality }}

Direction:

{{ selectedRelationship.direction }}

Relationship Type

This is a {{ selectedRelationship.cardinality }} relationship {{ selectedRelationship.active ? 'that is currently active' : 'that is currently inactive' }}. Cross-filtering behavior: {{ selectedRelationship.direction }}.